Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TillID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
OpenBalanceAmount | The opening tender balance in the TILL before closing the till settlement period. | MO_OPN_BLNC_AMT | Money | decimal(16,5) | |
OpenMediaUnitQuantity | The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before closing a till settlement period. | QU_OPN_MD | QuantityInteger | integer | |
CloseBalanceAmount | The closing system maintained tender balance in the TILL before formalizing the closing of a till settlement period. | MO_CL_BLNC_AMT | Money | decimal(16,5) | |
CloseMediaUnitQuantity | The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before the formal closing of a till settlement period. | QU_CL_MD_UN | QuantityInteger | integer | |
CountedBalanceAmount | The counted tender balance in the TILL before the fomal closing of a till settlement period. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. | MO_CNT_BLNC_AMT | Money | decimal(16,5) | |
CountedMediaUnitQuantity | The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before the formal closing of a till settlement period. | QU_CNT_MD_UN | QuantityInteger | integer | |
OverUnderBalanceAmount | The variance between closing balance amount and counted balance amount before the formal closing of a till settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) | MO_OVR_UND_BLNC_AMT | Money | decimal(16,5) | |
OverUnderMediaUnitQuantity | The variance between closing media unit quantity and counted media unit quantity before the closing of a till settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) | QU_OVR_UND_MD_UN | QuantityInteger | integer | |
LoanFromSafeAmount | The running total amount of tender loaded to this TILL from a SAFE during a till settlement period before it is formally closed. | MO_LON_FR_SF_AMT | Money | decimal(16,5) | |
LoanFromSafeMediaUnitQuantity | The running media unit quantityt of tender loaded to this TILL from a SAFE during a till settlement period before it is formally closed. | QU_LON_FR_SF_MD_UN | QuantityInteger | integer | |
PickupToSafeAmount | The running total amount of tender picked up from this TILL and moved to a SAFE during a till settlement period before that period is formally closed. | MO_PKP_TO_SF_AMT | Money | decimal(16,5) | |
PickupToSafeMediaUnitQuantity | The running total of media unit quantity of tender picked up from this TILL and moved to a SAFE during a till settlement period before that period is formally closed. | QU_PKUP_TO_SF_MD_UN | QuantityInteger | integer | |
TipOutAmount | The running sum of tip out transaction amounts removed from a till during the till settlement period before that period is formally closed. | TP_OT_AMT | Money | decimal(16,5) | |
TipOutMediaUnitQuantity | The running sum of tip out media unit quantities removed from a till during a till settlement period before that period is formally closed | QU_TP_OT_MD_UN | QuantityInteger | integer | |
DisbursementAmount | The running sum of tender disbursement amounts made from a TILL during a till settlement period before that period is formally closed. This is generally treated as a petty cash payment by retailers and is used to pay service vendors, charities, etc. from a till. | MO_DSB_AMT | Money | decimal(16,5) | |
DisbursementMediaUnitQuantity | The running total media unit quantity paid out of a till as a cash disbursement for a till settlement period before that period is formally closed. | QU_DSB_MD_UN | QuantityInteger | integer | |
RetailTransactionSettlementAmount | The running sum of tender settlement values for retail transactions processed during a till settlement period before that period is formally closed. Retail transaction settlement represent the receipt or paying out of tender as part of balancing a retail transaction (aka settling the transaction). A negative balance means that a balance is paid out to a customer (as in a refund). A positive balance reflects the normal case where tender (cash, db/cr card, check, coupon, gift certificate,EBT, etc.) is paid in to settle a purchase. | MO_RTL_TRN_STLM_AMT | Money | decimal(16,5) | |
RetailTransactionSettlementMediaUnitQuantity | The running sum of retail transaction media unit quantities collected as part of settling retail transactions during a till settlement period before that period is formally closed. | QU_RTL_TRN_STLM_MD_UN_QTY | QuantityInteger | integer | |
FundsReceiptAmount | The running sum of NON-RETAIL sale and non-loan related receipt of tender into a till over a till settlement period before the formal closing of that period. | MO_FND_RCT_AMT | Money | decimal(16,5) | |
FundsReceiptMediaUnitQuantity | The running sum of NON-RETAIL sale and non-loan related receipt of tender media unit quantity into a till over a till settlement period before that period is formally closed. | QU_FND_RCPT_MD_UN | QuantityInteger | integer | |
TenderExchangeAmount | Running sum of tender exchanged with other tills during the till settlement period before that period is formally closed. A negative value indicates a net outflow of tender amount exhanges. A positive value indiates a net inflow of tender amount exchanges. A zero value indicates an even exchange of tender amounts. | MO_TND_EXC_AMT | Money | decimal(16,5) | |
TenderExchangeMediaUnitQuantity | Running sum of tender media unit quantities exchanged with other tills during the till settlement period before that period is closed. A negative value indicates a net outflow of tender media unit quantity exhanges. A positive value indiates a net inflow of tender media unit quantity exchanges. A zero value indicates an even exchange of tender media unit quantity. | QU_TND_EXC_MD_UN | QuantityInteger | integer | |
AdjustmentAmount | The running sum of tender adjustment amount transactions for a till settlement period before that period is formally closed. | ADJT_AMT | Money | decimal(16,5) | |
AdjustmentMediaUnitQuantity | The running sum of tender adjustment media unit quantity transactions for a till settlement period before formally closing that period. | ADJT_MD_UN | QuantityInteger | integer | |